CREATE TABLE Booking (
BookingNo VARCHAR(3), NOT NULL,
MemberNo VARCHAR(3), NOT NULL,
BookingDateTime date, NOT NULL,
PickupDateTime datetime, NOT NULL,
PickupAddress VARCHAR(100), NOT NULL,
PickupCityID CHAR(50), NOT NULL,
PickupPostcode VARCHAR(8), NOT NULL,
DestinationAddress VARCHAR(100), NOT NULL,
DestinationCityID CHAR(50), NOT NULL,
DestinationPostcode VARCHAR(8), NOT NULL,
JourneyMileage INTEGER,
CarSize VARCHAR(20),
AssignedDriverNo VARCHAR(3), NOT NULL,
DeliveredDateTime datetime,
FareAmount money,
CancellationDateTime datetime,
CancellationCharge money,
PaymentDetails VARCHAR(50) );